<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html";>
<meta name="keywords" content="DeZign for Databases - HTML Report">
<meta name="author" content="Datanamic - www.datanamic.com">
<title>DeZign for Databases V4 - HTML Report</title>
<link rel="stylesheet" type="text/css" media="screen,print" href="dezign.css" title="report">
</head>
<body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10">
<div class="top">Logical model</div>
<ul id="menu">
<li><a href="index.html">Project details</a></li>
<li><a href="erdiagram.html">ER diagram</a></li>
<li><a href="entl.html">Entities</a></li>
<li><a href="attrl.html">Attributes</a></li>
<li><a href="rell.html">Relationships</a></li>
<li><a href="doml.html">Domains</a></li>
<li><a href="viewl.html">Views</a></li>
<li><a href="procl.html">Procedures</a></li>
</ul>
<div class="row">
<div class="tab"><a href="rell.html">List of relationships</a></div>
<div class="activetab">Relationship details</div>
</div>
<table width=90% border=0 cellSpacing=0 cellPadding=0 class="chapter">
<tr>
<td class="left" valign=top>
<ul id="objectbrowser">
<li><a href="#AdvertizingMethods_Sponsors_AdvertizingMethods">AdvertizingMethods_Sponsors_AdvertizingMethods</a></li>
<li><a href="#ApgEmailTemplates_APGs">ApgEmailTemplates_APGs</a></li>
<li><a href="#ApgEmailTemplates_Campaign">ApgEmailTemplates_Campaign</a></li>
<li><a href="#APGs_Clicks">APGs_Clicks</a></li>
<li><a href="#APG_Cap1">APG_Cap1</a></li>
<li><a href="#APG_Cap2">APG_Cap2</a></li>
<li><a href="#APG_Cap3">APG_Cap3</a></li>
<li><a href="#APG_Cap4">APG_Cap4</a></li>
<li><a href="#APG_Cap5">APG_Cap5</a></li>
<li><a href="#APG_Cap6">APG_Cap6</a></li>
<li><a href="#APG_Cap7">APG_Cap7</a></li>
<li><a href="#APG_Cap8">APG_Cap8</a></li>
<li><a href="#APG_Cap9">APG_Cap9</a></li>
<li><a href="#APG_Sponsor">APG_Sponsor</a></li>
<li><a href="#ASPs_Appointments">ASPs_Appointments</a></li>
<li><a href="#ASP_first_RC">ASP_first_RC</a></li>
<li><a href="#ASP_second_RC">ASP_second_RC</a></li>
<li><a href="#ASP_third_RC">ASP_third_RC</a></li>
<li><a href="#Campaign_Clicks">Campaign_Clicks</a></li>
<li><a href="#CateringContact_Events">CateringContact_Events</a></li>
<li><a href="#Contacts_Appointments">Contacts_Appointments</a></li>
<li><a href="#Contacts_ASPs">Contacts_ASPs</a></li>
<li><a href="#Contacts_Clicks">Contacts_Clicks</a></li>
<li><a href="#Contacts_Contacts">Contacts_Contacts</a></li>
<li><a href="#Contacts_Deposits">Contacts_Deposits</a></li>
<li><a href="#Contacts_EventParticipants">Contacts_EventParticipants</a></li>
<li><a href="#Contacts_Leads">Contacts_Leads</a></li>
<li><a href="#Contacts_Locations">Contacts_Locations</a></li>
<li><a href="#Contacts_RCs">Contacts_RCs</a></li>
<li><a href="#Contacts_Redemptions">Contacts_Redemptions</a></li>
<li><a href="#Contacts_SonsorRolodex">Contacts_SonsorRolodex</a></li>
<li><a href="#Contacts_Sponsors">Contacts_Sponsors</a></li>
<li><a href="#Contacts_Statements">Contacts_Statements</a></li>
<li><a href="#Contacts_WebinarParticipants">Contacts_WebinarParticipants</a></li>
<li><a href="#Contacts_Webinars">Contacts_Webinars</a></li>
<li><a href="#Coordinator_Events">Coordinator_Events</a></li>
<li><a href="#Coupons_Clicks">Coupons_Clicks</a></li>
<li><a href="#Coupons_Redemptions">Coupons_Redemptions</a></li>
<li><a href="#Deposits_EventParticipants">Deposits_EventParticipants</a></li>
<li><a href="#Deposits_WebinarParticipants">Deposits_WebinarParticipants</a></li>
<li><a href="#Emails_CcContact">Emails_CcContact</a></li>
<li><a href="#Emails_FromContact">Emails_FromContact</a></li>
<li><a href="#Emails_ToContact">Emails_ToContact</a></li>
<li><a href="#EmailTemplate_Emails">EmailTemplate_Emails</a></li>
<li><a href="#Events_EventParticipants">Events_EventParticipants</a></li>
<li><a href="#Locations_Events">Locations_Events</a></li>
<li><a href="#MailingLists_Campaign">MailingLists_Campaign</a></li>
<li><a href="#Markets_PrimaryMarket">Markets_PrimaryMarket</a></li>
<li><a href="#Markets_Sponsors_Markets">Markets_Sponsors_Markets</a></li>
<li><a href="#Markets_SynergesticMarkets">Markets_SynergesticMarkets</a></li>
<li><a href="#Packages_Sponsors_Packages">Packages_Sponsors_Packages</a></li>
<li><a href="#RCs_Appointments">RCs_Appointments</a></li>
<li><a href="#RCs_RC_Region">RCs_RC_Region</a></li>
<li><a href="#Referee_Contact">Referee_Contact</a></li>
<li><a href="#Referred_Contact">Referred_Contact</a></li>
<li><a href="#Sponsors_Coupons">Sponsors_Coupons</a></li>
<li><a href="#Sponsors_SonsorRolodex">Sponsors_SonsorRolodex</a></li>
<li><a href="#Sponsors_Sponsors_AdvertizingMethods">Sponsors_Sponsors_AdvertizingMethods</a></li>
<li><a href="#Sponsors_Sponsors_Markets">Sponsors_Sponsors_Markets</a></li>
<li><a href="#Sponsors_Sponsors_Packages">Sponsors_Sponsors_Packages</a></li>
<li><a href="#Sponsor_EventParticipants">Sponsor_EventParticipants</a></li>
<li><a href="#Webinars_WebinarParticipants">Webinars_WebinarParticipants</a></li>
<li><a href="#ZIP_Contacts">ZIP_Contacts</a></li>
<li><a href="#ZIP_Deposits">ZIP_Deposits</a></li>
<li><a href="#ZIP_Locations">ZIP_Locations</a></li>
<li><a href="#ZIP_RC_Region">ZIP_RC_Region</a></li>
</ul>
</td>
<td class="right" valign=top>
<A NAME="AdvertizingMethods_Sponsors_AdvertizingMethods"></A>
<div class="objectname">Relationship: AdvertizingMethods_Sponsors_AdvertizingMethods</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">AdvertizingMethods (advertizing_method_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Sponsors_AdvertizingMethods (advertizing_method_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ApgEmailTemplates_APGs"></A>
<div class="objectname">Relationship: ApgEmailTemplates_APGs</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">ApgEmailTemplates (template_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (template_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ApgEmailTemplates_Campaign"></A>
<div class="objectname">Relationship: ApgEmailTemplates_Campaign</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">One Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">ApgEmailTemplates (template_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Campaign (template_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APGs_Clicks"></A>
<div class="objectname">Relationship: APGs_Clicks</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">APGs (apg_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Clicks (apg_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap1"></A>
<div class="objectname">Relationship: APG_Cap1</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap1_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap2"></A>
<div class="objectname">Relationship: APG_Cap2</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap2_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap3"></A>
<div class="objectname">Relationship: APG_Cap3</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap3_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap4"></A>
<div class="objectname">Relationship: APG_Cap4</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap4_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap5"></A>
<div class="objectname">Relationship: APG_Cap5</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap5_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap6"></A>
<div class="objectname">Relationship: APG_Cap6</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap6_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap7"></A>
<div class="objectname">Relationship: APG_Cap7</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap7_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap8"></A>
<div class="objectname">Relationship: APG_Cap8</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap8_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Cap9"></A>
<div class="objectname">Relationship: APG_Cap9</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (cap9_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="APG_Sponsor"></A>
<div class="objectname">Relationship: APG_Sponsor</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">APGs (sponsor_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ASPs_Appointments"></A>
<div class="objectname">Relationship: ASPs_Appointments</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">ASPs (asp_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Appointments (asp_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ASP_first_RC"></A>
<div class="objectname">Relationship: ASP_first_RC</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">RCs (rc_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">ASPs (first_rc_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ASP_second_RC"></A>
<div class="objectname">Relationship: ASP_second_RC</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">RCs (rc_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">ASPs (second_rc_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ASP_third_RC"></A>
<div class="objectname">Relationship: ASP_third_RC</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">RCs (rc_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">ASPs (third_rc_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Campaign_Clicks"></A>
<div class="objectname">Relationship: Campaign_Clicks</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Campaign (campaign_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Clicks (campaign_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="CateringContact_Events"></A>
<div class="objectname">Relationship: CateringContact_Events</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Events (catering_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Appointments"></A>
<div class="objectname">Relationship: Contacts_Appointments</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Appointments (prospect_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_ASPs"></A>
<div class="objectname">Relationship: Contacts_ASPs</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">ASPs (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Clicks"></A>
<div class="objectname">Relationship: Contacts_Clicks</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Clicks (sponsor_cap_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Contacts"></A>
<div class="objectname">Relationship: Contacts_Contacts</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Contacts (referring_contact_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Deposits"></A>
<div class="objectname">Relationship: Contacts_Deposits</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Deposits (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_EventParticipants"></A>
<div class="objectname">Relationship: Contacts_EventParticipants</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">EventParticipants (participant_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Leads"></A>
<div class="objectname">Relationship: Contacts_Leads</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Leads (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Locations"></A>
<div class="objectname">Relationship: Contacts_Locations</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Locations (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_RCs"></A>
<div class="objectname">Relationship: Contacts_RCs</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">RCs (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Redemptions"></A>
<div class="objectname">Relationship: Contacts_Redemptions</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Redemptions (prospect_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_SonsorRolodex"></A>
<div class="objectname">Relationship: Contacts_SonsorRolodex</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">SonsorRolodex (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Sponsors"></A>
<div class="objectname">Relationship: Contacts_Sponsors</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Sponsors (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Statements"></A>
<div class="objectname">Relationship: Contacts_Statements</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Statements (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_WebinarParticipants"></A>
<div class="objectname">Relationship: Contacts_WebinarParticipants</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">WebinarParticipants (contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Contacts_Webinars"></A>
<div class="objectname">Relationship: Contacts_Webinars</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Webinars (instructor_contact_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Coordinator_Events"></A>
<div class="objectname">Relationship: Coordinator_Events</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Events (coordinator_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Coupons_Clicks"></A>
<div class="objectname">Relationship: Coupons_Clicks</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Coupons (coupon_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Clicks (coupon_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Coupons_Redemptions"></A>
<div class="objectname">Relationship: Coupons_Redemptions</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Coupons (coupon_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Redemptions (coupon_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Deposits_EventParticipants"></A>
<div class="objectname">Relationship: Deposits_EventParticipants</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Deposits (deposit_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">EventParticipants (deposit_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Deposits_WebinarParticipants"></A>
<div class="objectname">Relationship: Deposits_WebinarParticipants</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Deposits (deposit_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">WebinarParticipants (deposit_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Emails_CcContact"></A>
<div class="objectname">Relationship: Emails_CcContact</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Emails (cc_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Emails_FromContact"></A>
<div class="objectname">Relationship: Emails_FromContact</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Emails (from_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Emails_ToContact"></A>
<div class="objectname">Relationship: Emails_ToContact</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Emails (to_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="EmailTemplate_Emails"></A>
<div class="objectname">Relationship: EmailTemplate_Emails</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">EmailTemplate (email_template_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Emails (email_template_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Events_EventParticipants"></A>
<div class="objectname">Relationship: Events_EventParticipants</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Events (event_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">EventParticipants (event_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Locations_Events"></A>
<div class="objectname">Relationship: Locations_Events</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Locations (location_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Events (location_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="MailingLists_Campaign"></A>
<div class="objectname">Relationship: MailingLists_Campaign</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">MailingLists (mailing_list_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Campaign (to_mailing_list_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Markets_PrimaryMarket"></A>
<div class="objectname">Relationship: Markets_PrimaryMarket</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Markets (market_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">SynergesticMarkets (market_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Markets_Sponsors_Markets"></A>
<div class="objectname">Relationship: Markets_Sponsors_Markets</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Markets (market_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Sponsors_Markets (market_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Markets_SynergesticMarkets"></A>
<div class="objectname">Relationship: Markets_SynergesticMarkets</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">One Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Markets (market_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">SynergesticMarkets (syn_market_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Packages_Sponsors_Packages"></A>
<div class="objectname">Relationship: Packages_Sponsors_Packages</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Packages (package_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Sponsors_Packages (package_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="RCs_Appointments"></A>
<div class="objectname">Relationship: RCs_Appointments</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">RCs (rc_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Appointments (rc_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="RCs_RC_Region"></A>
<div class="objectname">Relationship: RCs_RC_Region</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">RCs (rc_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">RC_Region (rc_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Referee_Contact"></A>
<div class="objectname">Relationship: Referee_Contact</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Referrals (referee_contact_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Referred_Contact"></A>
<div class="objectname">Relationship: Referred_Contact</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Referrals (referred_by_contacts_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Sponsors_Coupons"></A>
<div class="objectname">Relationship: Sponsors_Coupons</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Coupons (sponsor_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Sponsors_SonsorRolodex"></A>
<div class="objectname">Relationship: Sponsors_SonsorRolodex</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">SonsorRolodex (sponsor_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Sponsors_Sponsors_AdvertizingMethods"></A>
<div class="objectname">Relationship: Sponsors_Sponsors_AdvertizingMethods</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Sponsors_AdvertizingMethods (sponsor_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Sponsors_Sponsors_Markets"></A>
<div class="objectname">Relationship: Sponsors_Sponsors_Markets</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Sponsors_Markets (sponsor_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Sponsors_Sponsors_Packages"></A>
<div class="objectname">Relationship: Sponsors_Sponsors_Packages</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Sponsors (sponsor_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Sponsors_Packages (sponsor_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Sponsor_EventParticipants"></A>
<div class="objectname">Relationship: Sponsor_EventParticipants</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Contacts (contacts_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">EventParticipants (sponsor_contact_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="Webinars_WebinarParticipants"></A>
<div class="objectname">Relationship: Webinars_WebinarParticipants</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">Webinars (webinar_id)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">WebinarParticipants (webinar_id)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ZIP_Contacts"></A>
<div class="objectname">Relationship: ZIP_Contacts</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">ZIP (ZIP_code)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Contacts (ZIP_code)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ZIP_Deposits"></A>
<div class="objectname">Relationship: ZIP_Deposits</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">ZIP (ZIP_code)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Deposits (billing_ZIP_code)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ZIP_Locations"></A>
<div class="objectname">Relationship: ZIP_Locations</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Non Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">ZIP (ZIP_code)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">Locations (ZIP_code)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
<A NAME="ZIP_RC_Region"></A>
<div class="objectname">Relationship: ZIP_RC_Region</div>
<div class="details">Relationship details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Type</td><td class="fielddata">Identifying</td></tr>
<tr><td class="fieldname">Cardinality</td><td class="fielddata">Zero Or More</td></tr>
<tr><td class="fieldname">Parent</td><td class="fielddata">ZIP (ZIP_code)</td></tr>
<tr><td class="fieldname">Child</td><td class="fielddata">RC_Region (ZIP_code)</td></tr>
<tr><td class="fieldname">Update rule</td><td class="fielddata">None</td></tr>
<tr><td class="fieldname">Delete rule</td><td class="fielddata">None</td></tr>
</table>
</td>
</tr>
</table>
</body>
</html>
